﻿IF object_id(N'dbo.UDS_CM_Linkman', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_CM_Linkman] (
        [ID]              int          NOT NULL identity(1, 1),
        [ClientID]        int          NOT NULL,
        [Name]            nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Mobile]          nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Telephone]       nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Position]        nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Email]           nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
        [Gender]          bit          NULL,
        [Description]     nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL,
        [Address]         nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
        [Family]          nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL,
        [LastContactTime] datetime     NULL,

        CONSTRAINT [PK_UDS_CM_Linkman] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
